<?php

require_once 'cf/db.php';
require_once 'cf/user.php';

cf\execQuery( file_get_contents(dirname(__FILE__)."/install.sql") );

$clientId = cf\User::register('client','client','Клиент');
$client2Id = cf\User::register('client2','client2','Клиент2');
$stylistId = cf\User::register('stylist','stylist','Стилист');
$sellerId = cf\User::register('seller','seller','Продавец');

cf\execQuery("
   UPDATE cf_users SET image='images/img31.jpg' WHERE id=$stylistId;

   INSERT INTO cf_user_roles (role_id,user_id) VALUES('client',$clientId);
   INSERT INTO cf_user_roles (role_id,user_id) VALUES('client',$client2Id);
   INSERT INTO cf_user_roles (role_id,user_id) VALUES('stylist',$stylistId);
   INSERT INTO cf_user_roles (role_id,user_id) VALUES('seller',$sellerId);
   
   INSERT INTO client_stylist (client_id,stylist_id) VALUES($clientId,$stylistId);
   INSERT INTO client_stylist (client_id,stylist_id) VALUES($client2Id,$stylistId);
   
   
   INSERT INTO look_types (name,client_id) VALUES('Бал',$clientId);
   INSERT INTO look_types (name,client_id) VALUES('Вечеринка',$clientId);
   INSERT INTO look_types (name,client_id) VALUES('Деловая встреча',$clientId);
   INSERT INTO look_types (name,client_id) VALUES('Каждый день',$clientId);
   INSERT INTO look_types (name,client_id) VALUES('Официальный прием',$clientId);
   
   
   INSERT INTO look_sets (name,client_id) VALUES('Каждый день',$clientId);
   INSERT INTO look_sets (name,client_id) VALUES('Деловая встреча',$clientId);
   
   INSERT INTO closets (id,name,owner_id) VALUES(10,'Лондон',$clientId);
   INSERT INTO closets (id,name,owner_id) VALUES(20,'Москва',$clientId);
   INSERT INTO closets (id,name,owner_id) VALUES(30,'Париж', $clientId);
   
   INSERT INTO closets (id,name,owner_id) VALUES(40,'Нью-Йорк',$client2Id);
   INSERT INTO closets (id,name,owner_id) VALUES(50,'Милан',$client2Id);
   

   
   INSERT INTO recommended_items (client_id,stylist_id,item_id) VALUES($clientId,$stylistId,5);
   INSERT INTO recommended_items (client_id,stylist_id,item_id) VALUES($clientId,$stylistId,6);
   
   INSERT INTO recommended_items (client_id,stylist_id,item_id) VALUES($clientId,$stylistId,18);
   INSERT INTO recommended_items (client_id,stylist_id,item_id) VALUES($clientId,$stylistId,29);
   
   INSERT INTO recommended_items (client_id,stylist_id,item_id) VALUES($clientId,$stylistId,27);
   INSERT INTO recommended_items (client_id,stylist_id,item_id) VALUES($clientId,$stylistId,28);
   
   INSERT INTO recommended_items (client_id,stylist_id,item_id) VALUES($clientId,$stylistId,37);
   INSERT INTO recommended_items (client_id,stylist_id,item_id) VALUES($clientId,$stylistId,38);
   INSERT INTO recommended_items (client_id,stylist_id,item_id) VALUES($clientId,$stylistId,39);

   
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Платье',1,'product_images/closet_dress1.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(10,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,1);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Платье',1,'product_images/closet_dress2.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(10,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,1);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Платье',1,'product_images/closet_dress3.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(10,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,1);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Платье',1,'product_images/closet_dress4.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(10,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,1);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());	
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Платье',1,'product_images/closet_dress5.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(10,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,1);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());	

	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Платье',1,'product_images/closet_dress6.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(10,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,1);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());	

	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Платье',1,'product_images/closet_dress7.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(10,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,1);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());	

	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Платье',1,'product_images/closet_dress8.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(10,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,1);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());	

	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Платье',1,'product_images/closet_dress9.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(10,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,1);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());	
	

	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Сумка',3,'product_images/closet_purse1.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(20,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,1);
    INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Сумка',3,'product_images/closet_purse2.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(20,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,1);
    INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Сумка',3,'product_images/closet_purse3.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(20,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,1);
    INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Сумка',3,'product_images/closet_purse4.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(20,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,1);
    INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Сумка',3,'product_images/closet_purse5.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(20,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,1);
    INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Сумка',3,'product_images/closet_purse6.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(20,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,1);
    INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Сумка',3,'product_images/closet_purse7.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(20,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,1);
    INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Сумка',3,'product_images/closet_purse8.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(20,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,1);
    INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Сумка',3,'product_images/closet_purse9.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(20,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,1);
    INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Сумка',3,'product_images/closet_purse10.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(20,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,1);
    INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Сумка',3,'product_images/closet_purse11.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(20,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,1);
    INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Сумка',3,'product_images/closet_purse12.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(20,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,1);
    INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());



   	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Аксесуар',1,'product_images/closet_accesory1.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(30,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());   
	
   	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Аксесуар',1,'product_images/closet_accesory2.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(30,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());   

   	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Аксесуар',1,'product_images/closet_accesory3.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(30,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());   

   	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Аксесуар',1,'product_images/closet_accesory4.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(30,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());   

   	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Аксесуар',1,'product_images/closet_accesory5.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(30,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());  
	
	
	
   	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Туфли',1,'product_images/closet_shoes1.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(40,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

   	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Туфли',1,'product_images/closet_shoes2.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(40,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

   	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Туфли',1,'product_images/closet_shoes3.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(40,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

   	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Туфли',1,'product_images/closet_shoes4.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(40,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

   	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Туфли',1,'product_images/closet_shoes5.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(40,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

   	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Туфли',1,'product_images/closet_shoes6.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(40,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

   	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Туфли',1,'product_images/closet_shoes7.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(40,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

   	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Туфли',1,'product_images/closet_shoes8.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(40,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

   	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Туфли',1,'product_images/closet_shoes9.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(40,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

   	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Туфли',1,'product_images/closet_shoes10.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(40,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

   	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Туфли',1,'product_images/closet_shoes11.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(40,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

   	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Туфли',1,'product_images/closet_shoes12.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(40,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

   	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Туфли',1,'product_images/closet_shoes13.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(40,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

   	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Туфли',1,'product_images/closet_shoes14.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(40,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());	

	
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Юбка',1,'product_images/closet_skirt1.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(50,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());	
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Юбка',1,'product_images/closet_skirt2.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(50,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Юбка',1,'product_images/closet_skirt3.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(50,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Юбка',1,'product_images/closet_skirt4.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(50,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Юбка',1,'product_images/closet_skirt5.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(50,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Юбка',1,'product_images/closet_skirt6.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(50,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());
	
	
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Брюки',1,'product_images/closet_pants1.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(60,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Брюки',1,'product_images/closet_pants2.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(60,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Брюки',1,'product_images/closet_pants3.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(60,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());

	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Брюки',1,'product_images/closet_pants4.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(60,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());
	


	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Кофта',1,'product_images/closet_jacket1.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(70,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());	
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Кофта',1,'product_images/closet_jacket2.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(70,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());	
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Кофта',1,'product_images/closet_jacket3.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(70,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());	
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Кофта',1,'product_images/closet_jacket4.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(70,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());	
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Кофта',1,'product_images/closet_jacket5.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(70,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());	
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Кофта',1,'product_images/closet_jacket6.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(70,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());	
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Кофта',1,'product_images/closet_jacket7.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(70,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());	
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Кофта',1,'product_images/closet_jacket8.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(70,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());	
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Кофта',1,'product_images/closet_jacket9.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(70,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());	



	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Пальто',1,'product_images/closet_coat1.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(80,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());		
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Пальто',1,'product_images/closet_coat2.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(80,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());	
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Пальто',1,'product_images/closet_coat3.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(80,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());	
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Пальто',1,'product_images/closet_coat4.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(80,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());	
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Пальто',1,'product_images/closet_coat5.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(80,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());	
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Пальто',1,'product_images/closet_coat6.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(80,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());	
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Пальто',1,'product_images/closet_coat7.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(80,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());	
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Пальто',1,'product_images/closet_coat8.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(80,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());	
	
	INSERT INTO cf_products (created,name,manufacturer_id,image1,state_id) VALUES(NOW(),'Пальто',1,'product_images/closet_coat9.png',2);
	SET @PID = LAST_INSERT_ID();
	INSERT INTO cf_products_in_groups(group_id,product_id) VALUES(80,@PID);
	INSERT INTO cf_product_attributes (product_id,attribute_id,attribute_value) VALUES(@PID,10,2);
	INSERT INTO closet_items (owner_id,closet_id,item_id,bought_date) VALUES($clientId,10,@PID,NOW());	
");

?>


